1. | getSingleRecord | getSingleRecord having GEN mapping. Create rest trigger to get customer data from DB and map the single record with GEN. Target keys will change | { "Id": 100, "Name": "Rajat Kulkarni", "City": "Boston", "Country": "USA" }
|
2. | getStatusCodeGlobal | get status code from global variables and content-type text/plain | {"Customer":{"customerNumber":100,"customerName":"Rajat Kulkarni","city":"Boston","country":"USA"}}
|
3. | getMultipleRecord | getMultipleRecord having AR mapping. Create rest trigger to get customers data from DB and map the multiple record with GEN. Target keys will change | { "Customers": [ { "Id": 100, "Name": "Rajat Kulkarni", "City": "Boston", "Country": "USA" }, { "Id": 103, "Name": "Atelier graphique", "City": "Amravati", "Country": "France" }, { "Id": 112, "Name": "Signal Gift Stores", "City": "Las Vegas", "Country": "USA" }, { "Id": 114, "Name": "Australian Collectors, Co.", "City": "Melbourne", "Country": "Australia" }, { "Id": 119, "Name": "La Rochelle Gifts", "City": "Nantes", "Country": "France" } ] }
|
4. | getArrayResponse | get array in response and content-type application/json | [ { "Id": 100, "Name": "Rajat Kulkarni", "City": "Boston", "Country": "USA" }, { "Id": 103, "Name": "Atelier graphique", "City": "Amravati", "Country": "France" }, { "Id": 112, "Name": "Signal Gift Stores", "City": "Las Vegas", "Country": "USA" }, { "Id": 114, "Name": "Australian Collectors, Co.", "City": "Melbourne", "Country": "Australia" }, { "Id": 119, "Name": "La Rochelle Gifts", "City": "Nantes", "Country": "France" } ]
|
5. | getArrayResponseTxt | get array in response and content-type text/plain and status-code 202 | [{"Id":100,"Name":"Rajat Kulkarni","City":"Boston","Country":"USA"},{"Id":103,"Name":"Atelier graphique","City":"Amravati","Country":"France"},{"Id":112,"Name":"Signal Gift Stores","City":"Las Vegas","Country":"USA"},{"Id":114,"Name":"Australian Collectors, Co.","City":"Melbourne","Country":"Australia"},{"Id":119,"Name":"La Rochelle Gifts","City":"Nantes","Country":"France"}]
|
6. | getFirstObject | Get first record from array using CN | { "customerNumber": 100, "customerName": "Rajat Kulkarni", "city": "Boston", "country": "USA" }
|
7. | postCNOBJ | Usage of Transformer where both input and output are JSON in REST POST request (ouput request_payload) TRansform in Java object. IN APIResponse using CN send data back as with content-type as application/json | { "ID": 1, "Name": "Minal", "LastName": "Deshpande", "FirstName": "Minal", "phone": "40.32.2555", "Address1": "Pune", "Address2": null, "city": "Pune", "state": null, "pincode": "411007", "country": "India", "salesRepEmployeeNumber": 1702, "creditLimit": 1451.25 }
{"ID":1,"Name":"Minal","LastName":"Deshpande","FirstName":"Minal","phone":"40.32.2555","Address1":"Pune","Address2":null,"city":"Pune","state":null,"pincode":"411007","country":"India","salesRepEmployeeNumber":1702,"creditLimit":1451.25}
|
8. | postTransUtils | Use of few inline functions: 1. Use `Strings.concat` method to concatenate 2 or more strings with an underscore `-` between them and `Utils.constant` to get a constant value. 2. Use `Strings.toUppercase` method to convert string to uppercase. 3. Use `Maths.add` method for addition of static and dynamic values with datatype `Number`. 4. Use `Strings.isAlphanumeric` to check if given text contains only letters and numbers. 5. Use `Maths.add` method for addition of static and dynamic values with datatype `Double`. 6. Use `Date.DateTime` method to get the current date and time. | { "name": "John Doe", "num1": 12, "num2": 34, "num3": 50, "price": 133, "text": "This sentence contains alphanumeric characters 00" }
{ "Constant Concat String": "Welcome to Atd Services-John Doe", "Uppercase Name": "JOHN DOE", "Total": 96, "isAlphanumeric": true, "Double Val": 233, "Date": "2024-12-05 10:35:10" }
|
9. | postJSONgetJSON | input is json APIRESPONSE component Content-Type-> application/json use CN with request_payload | { "ID": 1, "Name": "Minal", "LastName": "Deshpande", "FirstName": "Minal", "phone": "40.32.2555", "Address1": "Pune", "Address2": null, "city": "Pune", "state": null, "pincode": "411007", "country": "India", "salesRepEmployeeNumber": 1702, "creditLimit": 1451.25 }
{ "ID": 1, "Name": "Minal", "LastName": "Deshpande", "FirstName": "Minal", "phone": "40.32.2555", "Address1": "Pune", "Address2": null, "city": "Pune", "state": null, "pincode": "411007", "country": "India", "salesRepEmployeeNumber": 1702, "creditLimit": 1451.25 }
|
10. | postJSONgetXML | input is json APIRESPONSE component Content-Type-> application/xml use CN with request_payload | { "ID": 1, "Name": "Minal", "LastName": "Deshpande", "FirstName": "Minal", "phone": "40.32.2555", "Address1": "Pune", "Address2": null, "city": "Pune", "state": null, "pincode": "411007", "country": "India", "salesRepEmployeeNumber": 1702, "creditLimit": 1451.25 }
<?xml version='1.1' encoding='UTF-8'?> <root> <ID>1</ID> <Name>Minal</Name> <LastName>Deshpande</LastName> <FirstName>Minal</FirstName> <phone>40.32.2555</phone> <Address1>Pune</Address1> <Address2/> <city>Pune</city> <state/> <pincode>411007</pincode> <country>India</country> <salesRepEmployeeNumber>1702</salesRepEmployeeNumber> <creditLimit>1451.25</creditLimit> </root>
|
11. | postJSONgetCSV | input is json APIRESPONSE component Content-Type-> text/csv use CN with request_payload | { "ID": 1, "Name": "Minal", "LastName": "Deshpande", "FirstName": "Minal", "phone": "40.32.2555", "Address1": "Pune", "Address2": null, "city": "Pune", "state": null, "pincode": "411007", "country": "India", "salesRepEmployeeNumber": 1702, "creditLimit": 1451.25 }
ID,Name,LastName,FirstName,phone,Address1,Address2,city,state,pincode,country,salesRepEmployeeNumber,creditLimit 1,Minal,Deshpande,Minal,40.32.2555,Pune,,Pune,,411007,India,1702,1451.25
|
12. | postJsonArrGetCsv | input is json APIRESPONSE component Content-Type-> text/csv use CN with request_payload | [ { "ID": 1, "Name": "Minal", "LastName": "Deshpande", "FirstName": "Minal", "phone": "40.32.2555", "Address1": "Pune", "Address2": null, "city": "Pune", "state": null, "pincode": "411007", "country": "India", "salesRepEmployeeNumber": 1702, "creditLimit": 1451.25 } ]
ID,Name,LastName,FirstName,phone,Address1,Address2,city,state,pincode,country,salesRepEmployeeNumber,creditLimit 1,Minal,Deshpande,Minal,40.32.2555,Pune,,Pune,,411007,India,1702,1451.25
|
13. | postJSONgetTXT | input is json APIRESPONSE component Content-Type-> text/plain use CN with request_payload | { "ID": 1, "Name": "Minal", "LastName": "Deshpande", "FirstName": "Minal", "phone": "40.32.2555", "Address1": "Pune", "Address2": null, "city": "Pune", "state": null, "pincode": "411007", "country": "India", "salesRepEmployeeNumber": 1702, "creditLimit": 1451.25 }
{ "ID": 1, "Name": "Minal", "LastName": "Deshpande", "FirstName": "Minal", "phone": "40.32.2555", "Address1": "Pune", "Address2": null, "city": "Pune", "state": null, "pincode": "411007", "country": "India", "salesRepEmployeeNumber": 1702, "creditLimit": 1451.25 }
|
14. | postXMLgetJSON | input is json APIRESPONSE component Content-Type-> application/json use CN with request_payload | <Customer> <ID>1</ID> <Name>Minal</Name> <LastName>Deshpande</LastName> <FirstName>Minal</FirstName> <phone>40.32.2555</phone> <Address1>Pune</Address1> <Address2/> <city>Pune</city> <state/> <pincode>411007</pincode> <country>India</country> <salesRepEmployeeNumber>1702</salesRepEmployeeNumber> <creditLimit>1451.25</creditLimit> </Customer>
{ "ID": 1, "Name": "Minal", "LastName": "Deshpande", "FirstName": "Minal", "phone": "40.32.2555", "Address1": "Pune", "Address2": null, "city": "Pune", "state": null, "pincode": "411007", "country": "India", "salesRepEmployeeNumber": 1702, "creditLimit": 1451.25 }
|
15. | postXMLgetXML | input is json APIRESPONSE component Content-Type-> application/xml use CN with request_payload | <Customer> <ID>1</ID> <Name>Minal</Name> <LastName>Deshpande</LastName> <FirstName>Minal</FirstName> <phone>40.32.2555</phone> <Address1>Pune</Address1> <Address2/> <city>Pune</city> <state/> <pincode>411007</pincode> <country>India</country> <salesRepEmployeeNumber>1702</salesRepEmployeeNumber> <creditLimit>1451.25</creditLimit> </Customer>
<?xml version='1.1' encoding='UTF-8'?> <root> <ID>1</ID> <Name>Minal</Name> <LastName>Deshpande</LastName> <FirstName>Minal</FirstName> <phone>40.32.2555</phone> <Address1>Pune</Address1> <Address2/> <city>Pune</city> <state/> <pincode>411007</pincode> <country>India</country> <salesRepEmployeeNumber>1702</salesRepEmployeeNumber> <creditLimit>1451.25</creditLimit> </root>
|
16. | postXMLgetCSV | input is json APIRESPONSE component Content-Type-> text/csv use CN with request_payload | <Customer> <ID>1</ID> <Name>Minal</Name> <LastName>Deshpande</LastName> <FirstName>Minal</FirstName> <phone>40.32.2555</phone> <Address1>Pune</Address1> <Address2/> <city>Pune</city> <state/> <pincode>411007</pincode> <country>India</country> <salesRepEmployeeNumber>1702</salesRepEmployeeNumber> <creditLimit>1451.25</creditLimit> </Customer>
ID,Name,LastName,FirstName,phone,Address1,Address2,city,state,pincode,country,salesRepEmployeeNumber,creditLimit 1,Minal,Deshpande,Minal,40.32.2555,Pune,,Pune,,411007,India,1702,1451.25
|
17. | postXMLgetTXT | input is json APIRESPONSE component Content-Type-> text/plain use CN with request_payload | <Customer> <ID>1</ID> <Name>Minal</Name> <LastName>Deshpande</LastName> <FirstName>Minal</FirstName> <phone>40.32.2555</phone> <Address1>Pune</Address1> <Address2/> <city>Pune</city> <state/> <pincode>411007</pincode> <country>India</country> <salesRepEmployeeNumber>1702</salesRepEmployeeNumber> <creditLimit>1451.25</creditLimit> </Customer>
<Customer> <ID>1</ID> <Name>Minal</Name> <LastName>Deshpande</LastName> <FirstName>Minal</FirstName> <phone>40.32.2555</phone> <Address1>Pune</Address1> <Address2/> <city>Pune</city> <state/> <pincode>411007</pincode> <country>India</country> <salesRepEmployeeNumber>1702</salesRepEmployeeNumber> <creditLimit>1451.25</creditLimit> </Customer>
|
18. | postCSVgetJSON | input is json APIRESPONSE component Content-Type-> application/json use CN with request_payload | ID,Name,LastName,FirstName,phone,Address1,Address2,city,state,pincode,country,salesRepEmployeeNumber,creditLimit 1,Minal,Deshpande,Minal,40.32.2555,Pune,,Pune,,411007,India,1702,1451.25
[ { "ID": 1, "Name": "Minal", "LastName": "Deshpande", "FirstName": "Minal", "phone": "40.32.2555", "Address1": "Pune", "Address2": null, "city": "Pune", "state": null, "pincode": "411007", "country": "India", "salesRepEmployeeNumber": 1702, "creditLimit": 1451.25 } ]
|
19. | postCSVgetXML | input is json APIRESPONSE component Content-Type-> application/xml use CN with request_payload | ID,Name,LastName,FirstName,phone,Address1,Address2,city,state,pincode,country,salesRepEmployeeNumber,creditLimit 1,Minal,Deshpande,Minal,40.32.2555,Pune,,Pune,,411007,India,1702,1451.25
<?xml version='1.1' encoding='UTF-8'?> <root> <item> <ID>1</ID> <Name>Minal</Name> <LastName>Deshpande</LastName> <FirstName>Minal</FirstName> <phone>40.32.2555</phone> <Address1>Pune</Address1> <Address2/> <city>Pune</city> <state/> <pincode>411007</pincode> <country>India</country> <salesRepEmployeeNumber>1702</salesRepEmployeeNumber> <creditLimit>1451.25</creditLimit> </item> </root>
|
20. | postCSVgetCSV | input is json APIRESPONSE component Content-Type-> text/csv use CN with request_payload | ID,Name,LastName,FirstName,phone,Address1,Address2,city,state,pincode,country,salesRepEmployeeNumber,creditLimit 1,Minal,Deshpande,Minal,40.32.2555,Pune,,Pune,,411007,India,1702,1451.25
ID,Name,LastName,FirstName,phone,Address1,Address2,city,state,pincode,country,salesRepEmployeeNumber,creditLimit 1,Minal,Deshpande,Minal,40.32.2555,Pune,,Pune,,411007,India,1702,1451.25
|
21. | postCSVgetTXT | input is json APIRESPONSE component Content-Type-> text/plain use CN with request_payload | ID,Name,LastName,FirstName,phone,Address1,Address2,city,state,pincode,country,salesRepEmployeeNumber,creditLimit 1,Minal,Deshpande,Minal,40.32.2555,Pune,,Pune,,411007,India,1702,1451.25
ID,Name,LastName,FirstName,phone,Address1,Address2,city,state,pincode,country,salesRepEmployeeNumber,creditLimit 1,Minal,Deshpande,Minal,40.32.2555,Pune,,Pune,,411007,India,1702,1451.25
|
22. | postTXTgetJSON | input is json APIRESPONSE component Content-Type-> application/json use CN with request_payload | ID,Name,LastName,FirstName,phone,Address1,Address2,city,state,pincode,country,salesRepEmployeeNumber,creditLimit 1,Minal,Deshpande,Minal,40.32.2555,Pune,,Pune,,411007,India,1702,1451.25
{ "ID": 1, "Name": "Minal", "LastName": "Deshpande", "FirstName": "Minal", "phone": "40.32.2555", "Address1": "Pune", "Address2": null, "city": "Pune", "state": null, "pincode": "411007", "country": "India", "salesRepEmployeeNumber": 1702, "creditLimit": 1451.25 }
|
23. | postTXTgetXML | input is json APIRESPONSE component Content-Type-> application/xml use CN with request_payload | ID,Name,LastName,FirstName,phone,Address1,Address2,city,state,pincode,country,salesRepEmployeeNumber,creditLimit 1,Minal,Deshpande,Minal,40.32.2555,Pune,,Pune,,411007,India,1702,1451.25
<?xml version='1.1' encoding='UTF-8'?> <root> <item> <ID>1</ID> <Name>Minal</Name> <LastName>Deshpande</LastName> <FirstName>Minal</FirstName> <phone>40.32.2555</phone> <Address1>Pune</Address1> <Address2/> <city>Pune</city> <state/> <pincode>411007</pincode> <country>India</country> <salesRepEmployeeNumber>1702</salesRepEmployeeNumber> <creditLimit>1451.25</creditLimit> </item> </root>
|
24. | postTXTgetCSV | input is json APIRESPONSE component Content-Type-> text/csv use CN with request_payload | ID,Name,LastName,FirstName,phone,Address1,Address2,city,state,pincode,country,salesRepEmployeeNumber,creditLimit 1,Minal,Deshpande,Minal,40.32.2555,Pune,,Pune,,411007,India,1702,1451.25
ID,Name,LastName,FirstName,phone,Address1,Address2,city,state,pincode,country,salesRepEmployeeNumber,creditLimit 1,Minal,Deshpande,Minal,40.32.2555,Pune,,Pune,,411007,India,1702,1451.25
|
25. | postTXTgetTXT | input is json APIRESPONSE component Content-Type-> text/plain use CN with request_payload | ID,Name,LastName,FirstName,phone,Address1,Address2,city,state,pincode,country,salesRepEmployeeNumber,creditLimit 1,Minal,Deshpande,Minal,40.32.2555,Pune,,Pune,,411007,India,1702,1451.25
ID,Name,LastName,FirstName,phone,Address1,Address2,city,state,pincode,country,salesRepEmployeeNumber,creditLimit 1,Minal,Deshpande,Minal,40.32.2555,Pune,,Pune,,411007,India,1702,1451.25
|